home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vbusprobedetail.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
36 lines
/*
shows detail of coins and bills for probed cash. otherwise has same data as vbusprobe50
*/
CREATE OR REPLACE VIEW VBUSPROBEDETAIL AS
select probehist.pdate,
probehist.conversion_num,
probehist.cbintent pull,
vbpmoneydet.probedcash,
vbpmoneydet.cents_$,
vbpmoneydet.nickels_$,
vbpmoneydet.dimes_$,
vbpmoneydet.quarters_$,
vbpmoneydet.halfs_$,
vbpmoneydet.sbas_$,
vbpmoneydet.coin_total,
vbpmoneydet.ones_$,
vbpmoneydet.fives_$,
vbpmoneydet.tens_$,
vbpmoneydet.twenties_$,
vbpmoneydet.bill_total,
vbpmoneydet.totalcash,
vbpmoneydet.cashbox_glid,
vbpmoneydet.close_count,
vprevinsert.insert_date,
probehist.farebox_GLID ,
BUS.BUS_ID ,
GARAGE.GARAGE_ID
from probehist, vbpmoneydet , vprevinsert , farebox, bus , garage
where probehist.conversion_num = vbpmoneydet.conversion_num and
vbpmoneydet.conversion_num = vprevinsert.conversion_num(+) and
vbpmoneydet.close_count = vprevinsert.close_count(+) and
PROBEHIST.FAREBOX_GLID = FAREBOX.GLID AND
FAREBOX.LOCATION = BUS.GLID AND
BUS.GARAGEID = GARAGE.GLID;